Logging on to MS SQL Server via ODBC

This section is intended as an example of how to log on to a Microsoft SQL Server™ data source from Crystal Reports. Your SQL server application or any other password-protected data source may require different steps.

To log on to MS SQL Server via ODBC
  1. Verify the settings for the Microsoft SQL Server data source using ODBC Administrator. See Checking settings for an ODBC data source.
  2. From Crystal Reports, choose Log On/Off Server from the Database menu.

    If no report is open, choose Log On/Off Server from the File menu.

    The Data Explorer dialog box appears.

    Choose a SQL Server data source and then click Log On. The CRSS data source is automatically created in the ODBC folder during installation. This data source allows you to open MS SQL Server databases.

  3. The SQL Server Login dialog box appears.

  4. Type your MS SQL Server login ID and password.
  5. Click Options.

    The Options section of the SQL Server Login dialog box appears.

  6. Verify the settings for your SQL Server.
  7. Verify the name of the SQL Server database you want to open, the database language you want to use, the name of the application you are using (Crystal Reports), and the name of your computer workstation. Make any changes necessary.
  8. Click OK.


Seagate Software IMG Holdings, Inc.
http://www.seagatesoftware.com
Support services:
http://support.seagatesoftware.com